Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Target table is empty for BigQuery INSERT statement #693

Open
jacgeo opened this issue Mar 3, 2025 · 0 comments
Open

Target table is empty for BigQuery INSERT statement #693

jacgeo opened this issue Mar 3, 2025 · 0 comments
Labels
bug Something isn't working

Comments

@jacgeo
Copy link

jacgeo commented Mar 3, 2025

Describe the bug
For BigQuery INSERT statement, 'INTO' is an optional keyword. When tried a parse a BigQuery INSERT statement without INTO keyword, the target table is empty.

https://cloud.google.com/bigquery/docs/reference/standard-sql/dml-syntax#insert_statement

SQL

INSERT `project.dataset.table_2`
SELECT * FROM `project.dataset.table_1`;

To Reproduce
Note here we refer to SQL provided in prior step as stored in a file named test.sql

sqllineage -f test.sql --dialect=bigquery

Output

Statements(#): 1
Source Tables:
    project.dataset.table_1
Target Tables:
    

Expected behavior
Expected output

Statements(#): 1
Source Tables:
    project.dataset.table_1
Target Tables:
    project.dataset.table_2

Python version (available via python --version)

  • 3.12.3

SQLLineage version (available via sqllineage --version):

  • 1.5.4

Additional context
Add any other context about the problem here.

@jacgeo jacgeo added the bug Something isn't working label Mar 3, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant