- 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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-22-2023 01:16 AM
that is weird indeed.
Are you sure the manual test you did has the same code as the one in the job (perhaps different REPOS branch?)?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-22-2023 02:05 AM
I am sure that I use a same code in both.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-22-2023 04:48 AM
Jobs are just notebooks executed in background, so if the notebook is the same between interactive (manual) and job run, there should be no difference.
So I don't see what is wrong. Is the job using DLT perhaps?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-24-2023 05:13 AM
Ok, Sorry for this problem, I just found the different. It's a version of runtime that on my manual use 12.2 but on my job use 13.3. Thank you for your advice to check the different.
