Save reusable query templates in Google Sheets
The Databricks Connector for Google Sheets now lets you save imports as reusable templates in Unity Catalog.
O que mudou
The Databricks Connector for Google Sheets now allows you to save sets of imports as reusable templates directly in Unity Catalog. Templates store only the query definitions, ensuring that each user runs the queries using their own access permissions.### Use casesImagine your business team needs to pull recurring reports in Google Sheets using the same tables and filters. With templates, you avoid rewriting queries manually and standardize data extraction.- Create template groups to organize related queries.- Share templates with specific users or the entire account.- Import queries in bulk into any spreadsheet with a single click.### How to useTo set up the feature for the first time in the connector sidebar, use Unity Catalog commands to grant the required permissions and create the default catalog structure.sql-- Example of granting catalog usage for templates in Unity CatalogGRANT USE CATALOG ON CATALOG spreadsheet_templates TO my_user;GRANT USE SCHEMA ON SCHEMA spreadsheet_templates.gsheet_templates TO my_user;What happens in this code:1. The administrator grants usage access to the catalog created for template storage.2. The administrator grants usage access to the specific schema so users can view the templates.### Limitations and requirements- Templates store only query definitions, not the imported data.- You cannot edit query text directly within a template; you must delete and recreate the template to make changes.- You cannot create templates from the Databricks UI or from Databricks saved queries.
- google sheets
- unity catalog
- connector
- queries
- governance
Save reusable query templates in Google Sheets
Resumo e explicação gerados por IA a partir da release note oficial. Em caso de dúvida, a documentação oficial da plataforma prevalece.
Relacionadas
- DatabricksGA
Repositórios de pacotes em nível de workspace para Databricks Apps
Administradores de workspace podem configurar repositórios padrão de pacotes Python e npm para Databricks Apps.
databricks apps · workspace settings - DatabricksGA
Redimensione partições de stateful streaming sem perder o checkpoint no Databricks
Agora é possível alterar o número de partições de shuffle em queries Structured Streaming e pipelines Lakeflow sem descartar o estado do checkpoint.
structured streaming · lakeflow - DatabricksAtualização
Google Gemini 4 Argon disponível no Unity Gateway do Databricks
O modelo multimodal Google Gemini 4 Argon já pode ser acessado via Foundation Model APIs e Unity Gateway.
unity catalog · foundation model apis