Prismatic Martian

PostsComments

XXata

•Created by Prismatic Martian on 8/18/2024 in #help

Schema and tables

Thanks for clarifying this, no problem, I'll go with the SQL IDE route of pre-seeding data and take it from there. Cheers.

16 replies

XXata

•Created by Prismatic Martian on 8/18/2024 in #help

Schema and tables

Ah excellent. Thanks for testing it.

16 replies

XXata

•Created by Prismatic Martian on 8/18/2024 in #help

Schema and tables

This is one of the csv files. Looking at the last two columns, it seems a common date time stamp, but after loading the file in Xata, you get the first screenshot. So Xata adds the name of day, the name of month, the conversion to GMT, and when I change to format to timestampz, it actually shows how it's in the csv

16 replies

XXata

•Created by Prismatic Martian on 8/18/2024 in #help

Schema and tables

Just to follow up on your initial reply, would it be possible to create the schemas and tables through an SQL IDE like dbeaver?

16 replies

XXata

•Created by Prismatic Martian on 8/18/2024 in #help

Schema and tables

16 replies

XXata

•Created by Prismatic Martian on 8/18/2024 in #help

Schema and tables

Will get back to you on this asap. It is the public available airbnb dataset but i can make some screenshots to show.

16 replies

XXata

•Created by Prismatic Martian on 8/18/2024 in #help

Schema and tables

Thanks Kostas, will look into this. I also encountered another error, Xata didn't recognized my date/timestamp column so I manually selected, and it went all red.

16 replies