Hi All,I have a databricks table with the below DDL:CREATE TABLE default.Test (
ID BIGINT GENERATED ALWAYS AS IDENTITY (START WITH 1 INCREMENT BY 1),
StopFromDateTime TIMESTAMP,
StopToDateTime TIMESTAMP,
User STRING)
USING delta
TBLPROPERTIE...
I have a sql query which provides me with the below output :Select FirstName,LastName,Title From Default.Name
Tony Gonzalez Mr
Tom Brady Mr
Patricia Carroll MissI would like to store FirstName, LastName & title column output...
Hi,I have a table with XML data in it which is stored in a column with STRING datatype. Can someone please help me on how to parse this XML into multiple sql columns.Below is the sample XML Table & desired output data Select * from default.SampleDat...
Hi Walter,Thanks for the response, so when i drop and re-create the table i will be losing the data correct? So how can i move the data over if i have to drop and re-create? Or if i restore it to the version number which had 3 records and then delete...
Adding more information that needs to be done in below : My API Call looks something like this: ( Ignore the format & coding as this is a test code the actual code i have works fine)from zeep import Client
from zeep.transports import Transport
from r...
Even though the data in the column seems like a JSON formatted the data type is string, so using your code and suggestions from databricks below is the code i have tried below code: SELECT *, get_json_object(XMLData, '$.Response.IdNumber') AS id_n...
