Databricks Community

Rajani · 07-11-2024

I have this usecase wherein i am supposed to pass a dynamic query to get data from source I have tried the query option but its giving error SparkConnectGrpcException: (com.microsoft.sqlserver.jdbc.SQLServerException) Incorrect syntax near the keywor...

Rajani · 07-14-2024

Hi thanks for your reply,I have used foreign catalouge to fetch required data from information schema then i am creating the dynamic query in databricks and then passing in query this is working for me! @Retired_mod

Rajani · 07-11-2024

Hi @szymon_dybczak you are right we can create a temp view in main notebook and use it in the same session.but is there any option for creating a global variable which i can use across notebook for same session.I tried creating global in main and usi...

Rajani · 04-22-2024

Hi @databricksdev i dont think we can change the job name.

Rajani · 04-21-2024

Hi @BrianJ I just tested job trigger type it is working fine.attaching snippets for your reference

Rajani · 04-21-2024

Hi @niruban In ideal scenario it should not delete the exsting workflowI am also using databricks bundle to deploy the prod env but it has never deleted the current workflow.Can you send me the snippet where you can see workflow is delete?

Databricks Community

User Stats

User Activity

How to pass a dynamic query to source server from databricks

Re: How to pass a dynamic query to source server from databricks

Re: cluster sharing between different notebooks

Re: Can we customize job run name when running azure data bricks notebook jobs from azure data facto

Re: {{job.trigger.type}} not working and throws error on Edit Parameter from Job page

Re: Databricks Asset Bundle to deploy only one workflow