Issue I have a requirement where in I need to update XML data stored in a Snowflake table. Can we update an XML document/element stored in a table with column data type as Variant In the following example, need to
Continue readingTag: snowflake-cloud-data-platform
[SOLVED] Python entire XML file to list and then into dataframe, missing most of the file
Issue My final goal is to take each xml file and enter the raw format of the XML into Snowflake, and this is the result I have so far. For some reason though when i convert the list to a
Continue reading[SOLVED] Snowflake – how to split a single field (VARIANT) into multiple columns
Issue Within Snowflake how could I split a string of data that’s in a single field into multiple columns? This field is in a View and a type of Variant. My View that I’m querying has 12 actual columns. 1
Continue reading[SOLVED] Snowflake session policy with idle timeout doesn't terminate sessions. Even with KEEP_ALIVE=false
Issue Context I am trying to reproduce the case where a session gets closed by inactivity. There is ‘manual’ way of doing it, which is to run SYSTEM$ABORT_SESSION(<session_id>), making your session no longer active. That’s ok, but I’m trying to
Continue reading[SOLVED] Snowflake – Date column has character, can't convert to datetime
Issue I have several columns that look like this with a T and +: 2020-04-11T21:00:09+0000 I want to convert them to datetime if possible, I’ve tried to_timestamp_ntz() and to_date(): to_timestamp_ntz(‘2020-04-11T21:00:09+0000’, ‘YYYY-MM-DD HH24:MI:SS.FF+00′) but I keep seeing: Can’t parse ‘2020-04-11T21:00:09+0000’ as
Continue reading[SOLVED] SnowFlake stored procedure to delete a row from a table based on a condition
Issue I’m deleting a row from a table based on the where condition, but I don’t understand where I’m going wrong I have a table TABLE1 as follows ——————————- | DB | SC | TB | COLUMNS | ——————————- |
Continue reading[SOLVED] Could not build wheels for snowflake-connector-python which use PEP 517
Issue I am getting the following error while trying to install snowflake connector pin Spyder IDE in Windows 10 Pro having python 3.8.3 and PIP version pip 20.2.2 "Failed building wheel for snowflake-connector-python ERROR: Could not build wheels for snowflake-connector-python
Continue reading[SOLVED] Snowflake SQL – Find missing values within a variable VARCHAR range, with multiple table join
Issue Ok, so I’ve done a lot of digging and trying all sorts of snippets and solutions for other people’s queries, but I just can’t seem to get any traction here. Also, only started trying sql 2 weeks ago, so
Continue reading[SOLVED] Get row with largest negative number, or row with smallest number if there are no negative numbers
Issue I’m trying to write a Snowflake SQL statement that does the following: If there are negative numbers in column_A, return the row with the biggest negative number in column_A If there are no negative numbers in column_A, return the
Continue reading[SOLVED] Finding Substring Using REGEX_SUBSTR
Issue I am trying to extract the sub-string of Twitter and Fortnite, Facebook and Words with Friends, & Expedia and Notion from the strings below. These are just examples and the common pattern amongst all of them is "AppNames";s:xx:" with
Continue reading