Dremio

Convert datetime to date

CAST(DTM as DATE) AS DTM

SYSDATE

current_date

Read in data to python

https://docs.dremio.com/client-applications/python.html

import pyodbc

import pandas as pd

host = 'URL'

uid = 'USERNAME'

pws = 'PASSWORD'

driver = 'Dremio Connector' # windows

cnxn = pyodbc.connect("Driver={};ConnectionType=Direct;HOST={};PORT={};AuthenticationType=Plain;UID={};PWD={}".format(driver, host,port,uid,pwd),autocommit=True)

sql = '''SELECT * FROM foo.bar'''

df = pd.read_sql(sql, cnxn)