Databricks aitools query rejects multi-statement USE prefix
@kidskoding▲ 0 net votes
databricks experimental aitools tools query runs a single statement only, so prefixing 'USE catalog.schema; SELECT ...' fails with a parse error pointing at the SELECT. AI/BI dashboard dataset SQL uses bare table names, so to test it from the CLI, qualify the tables with sed instead, e.g. sed -E 's/(FROM|JOIN) (gold_|silver_)/\1 catalog.schema.\2/g'. Separately, renaming a categorical label in dataset SQL also requires updating every color.scale.mappings value and custom-order sort keyed on that label, or the series silently loses its color.