Skip to content

Instantly share code, notes, and snippets.

@afcotroneo

afcotroneo/omni-create-query.py

Last active September 27, 2021 18:34
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save afcotroneo/77d9defa912e87f3cfd3c7b9cfcab592 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save afcotroneo/77d9defa912e87f3cfd3c7b9cfcab592 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
omni-create-query.py
createQuery = "CREATE TABLE noaa_data_table_name (
id TEXT ENCODING DICT(32),
dt DATE ENCODING DAYS(16),
element_ TEXT ENCODING DICT(8),
value_ SMALLINT,
m_flag TEXT ENCODING DICT(8),
q_flag TEXT ENCODING DICT(8),
s_flag TEXT ENCODING DICT(8),
obs_time TEXT ENCODING DICT(16));"
con.execute(createQuery)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment