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

BUG: IF NOT EXISTS not working properly with CREATE TABLE #2899

Closed
talagluck opened this issue Apr 15, 2024 · 0 comments · Fixed by #2901
Closed

BUG: IF NOT EXISTS not working properly with CREATE TABLE #2899

talagluck opened this issue Apr 15, 2024 · 0 comments · Fixed by #2901
Labels
bug Something isn't working

Comments

@talagluck
Copy link
Contributor

Description

I am trying to do:

CREATE TABLE IF NOT EXISTS dbt_nyc_sales AS 
SELECT * FROM  read_parquet('https://github.com/GlareDB/tutorial_data/raw/main/nyc_sales/sale_year=2019/sale_month=1/f55363e2587849bcb25c057be706c69d-0.parquet')

When I try this on Cloud (QA), every time I run the command, it appends the data from the parquet file to my table, where I would expect it to not do anything once the table exists.

@talagluck talagluck added the bug Something isn't working label Apr 15, 2024
@talagluck talagluck changed the title IF NOT EXISTS not working properly with CREATE TABLE BUG: IF NOT EXISTS not working properly with CREATE TABLE Apr 15, 2024
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

Successfully merging a pull request may close this issue.

1 participant