Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-22-2023 01:06 AM
Hi , I have some mysteries situation here
My workflow (job) ran and got an error -> [INVALID_IDENTIFIER] The identifier transactions-catalog is invalid. Please, consider quoting it with back-quotes as `transactions-catalog`.(line 1, pos 12) == SQL == transactions-catalog.transactions-schema.transactions_bronze_table_eu
But when I ran it with manually it was success.
Is anyone have any idea about this
Coding
%python
silver_df = spark.sql(f"""
SELECT
column
from table_changes("`transactions-catalog`.`transactions-schema`.table" , {start_version} , {end_version})
""")
***I conceal a column and a table name.
