Databricks Community

kellybe · 07-04-2023

Hi,I'm trying to assign a location to a new database in Databricks SQL. Normally I'd do this in Python since we specify storage account names from secret scopes, however I'm attempting to do all of this from a SQL warehouse. When doing this I seem to...

kellybe · 07-04-2023

Hi @pcbzmani ,Unfortunately that doesn't seem to work. The issue appears to be with the use of format_string[PARSE_SYNTAX_ERROR] Syntax error at or near 'format_string'.line 2, pos 9 == SQL == CREATE DATABASE IF NOT EXISTS new_database LOCATION form...

kellybe · 07-04-2023

The SECRET function takes a secret scope and a key and returns the specified secret as a string.Here are the docs for it: https://docs.databricks.com/sql/language-manual/functions/secret.html

kellybe · 07-04-2023

We store environment variables as secrets to maintain consistency across our various environments.

Databricks Community

User Stats

User Activity

Databricks SQL format_string in LOCATION

Re: Databricks SQL format_string in LOCATION

Re: Databricks SQL format_string in LOCATION

Re: Databricks SQL format_string in LOCATION