Databricks Community

MR_DHC · 08-26-2025

I am trying to pass the year as argument so it can be used in the table name. Ex: there are tables like Claims_total_2021 , Claims_total_2022 and so on till 2025. Now I want to pass the year in parameter , say 2024 and it must fetch the table Claims...

MR_DHC · 08-26-2025

Hi Again! Sorry to trouble , this is still causing the error: [PARSE_SYNTAX_ERROR] Syntax error at or near '$'. SQLSTATE: 42601 == SQL (line 1, position 1) == EXECUTE IMMEDIATE sql_str

MR_DHC · 08-26-2025

Hi Martinson,Thank you for the response. I tried using VAR and it still throws syntax error at || . so I tried $ it still has same error:[PARSE_SYNTAX_ERROR] Syntax error at or near '||'. SQLSTATE: 42601 line 3, pos 95

Databricks Community

User Stats

User Activity

Execute Immediate not working to fetch table name based on year

Re: Execute Immediate not working to fetch table name based on year

Re: Execute Immediate not working to fetch table name based on year