topic Re: I'm trying to create a table in databricks sql using widget values in table naming. The idea is that the users could select / enter table naming values as they create their tables. This can be done in notebooks but I can't get the syntax working in DBSQL. in Data Engineering

I'm trying to create a table in databricks sql using widget values in table naming. The idea is that the users could select / enter table naming values as they create their tables. This can be done in notebooks but I can't get the syntax working in DBSQL.

Juha — Fri, 27 Jan 2023 07:39:17 GMT

Here's an example:

CREATE OR REPLACE TABLE {{workspace}}.{{TableNameFirstPart}}_{{TableNameEndPart}}

AS SELECT ...

Ajay-Pandey — Fri, 27 Jan 2023 13:04:04 GMT

Hi @Juha Leppänen please refer below code-

val = '2020-04-08'
 
spark.sql("SELECT * FROM MYTABLE WHERE TIMESTAMP  BETWEEN {}  AND '2020-04-08'".format(val)).show()

Juha — Mon, 30 Jan 2023 06:23:23 GMT

Hi @Ajay Pandey and thank you for your response, but this doesn't answer my question.

lawrence009 — Sun, 20 Aug 2023 03:29:14 GMT

Have you figured out what the problem was? Could the issue be permission related?