planning a deep dive in #snowflake loading files via COPY and all its possible options, all file types + utility checks like infer_schema, file records bigger than VARIANT 16MB and all different ways getting feedback of all bad records π
@FranckPachot@connor_mc_d funny enough today asked ChatGPT to see if it return right sql of SHOW <special obj type> in snowflake, and it generated a show with a where that it picked from select/join (not supported but funny enough.
ChatGPT should integrate compiler to check syntax (at least) π
@FranckPachot@connor_mc_d I understand, and of course there's no magic bullet but.. I got bit surprised. Did you tried it for real ? asking technical question in some context? i tried and got more surprised than i thought.
@FranckPachot@connor_mc_d Wow, and indeed we arrived/living in the nowfuture, yesterday asked ChatGPT about couple edge oauth setup cases and got clean nice answer..this is the future, people want answers and NOT waste time crawling from dozens websites and content which still need time to further curate
Google have great directory of known Open Source with security vulnerabilities called OSV:
- WebUI frontend to search: https://t.co/bA8zOBVyI1
- repo: https://t.co/nw6Q6I5Kaz
@sky_vst@ora600pl vs code is one of many i use, but as sql developer i havent found a way to show nice results in some graphic data grid.. i managed to connect to databses using sqltools extension, but results are plain text. and execution also lacks real database tools..