Skip to content
Lucas Lessa
Voltar para as notícias
DatabricksAtualizaçãoImpacto: Médio

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.

Ver nota oficial do Databricks

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