Hi, By getting the file with the Stage like in the Video, i Receive a file, which includes csv, json and parquet datasets. This is making a Problem singe the Stage is using the file format which is csv….does anyone know, Why the dataset is not only csv or does someone had the same issue????
For anyone, who is having the same Issue, i found the solution: When you Import from the Worksheet, you need to add: copy into trips from @citibike_trips file_format=CSV ON_ERROR = CONTINUE
Note on creating external stage: Make sure to include the final forward slash (/) at the end of the URL or you will encounter errors later when loading data from the bucket.
Amazing video !.. I am new to snowflake, saw many videos in youtube couldn't able to match there level , after seeing this video I am feeling even I can learn snowflake and level of confidence is getting higher, thanks a lot for you support.... wish you all the best , keep going
Hi, When I am trying to load staged file it is giving me this error: Number of columns in file (1) does not match that of the corresponding table (16), use file format option error_on_column_count_mismatch=false to ignore this error File 'citibike-trips-parquet/2013/06/03/data_01a19496-0601-8b21-003d-9b03003c624a_2106_4_0.snappy.parquet', line 2, character 1 Row 1 starts at line 1, column "TRIPS"["TRIPDURATION":1] If you would like to continue loading when an error is encountered, use other values such as 'SKIP_FILE' or 'CONTINUE' for the ON_ERROR option. For more information on loading options, please run 'info loading_data' in a SQL client. Can someone please help me to resolve this error. Thanks
I am trying my hands on snowflake for the first time and my user interface looks totally different to what you are showing here?, has there been any sort of update as it is a bit confusing to trace stuff in the new UI
When introducing an application, it’s important to keep it simple and avoid jargon. Unfortunately, this presentation missed the mark. It seems that simplicity has become a lost art.
Loading data>.not working>showing the error Found character '\u0006' instead of field delimiter ',' File 'citibike-trips-parquet/2013/06/05/data_01a19496-0601-8b21-003d-9b03003c624a_206_2_0.snappy.parquet', line 323, character 593 Row 323, column "TRIPS"["START_STATION_ID":4] If you would like to continue loading when an error is encountered, use other values such as 'SKIP_FILE' or 'CONTINUE' for the ON_ERROR option. For more information on loading options, please run 'info loading_data' in a SQL client. please help