Datahub SQL Parser Issue with ALTER TABLE Query

ingestion
1

Original Slack Thread

Hi, I’m currently using Datahub 0.12.1 with Airflow and Redshift as sources. I’ve noticed an issue with the SQL parser. For queries of the kind ALTER TABLE schema_name.table_name RENAME TO new_table_name the parser registers both table names as inputs and also assigns the public/default schema to the second table which is not how the query is executed. It’s something we need resolved, we worked around it, but might be worth bringing up here.

2

Hey there! :wave: Make sure your message includes the following information if relevant, so we can help more effectively!

  1. Are you using UI or CLI for ingestion?
  2. Which DataHub version are you using? (e.g. 0.12.0)
  3. What data source(s) are you integrating with DataHub? (e.g. BigQuery)