import snowflake_config
import pandas as pd


cnx = snowflake_config.credentials.cursor()

INSERT_QUERY = snowflake_config.load_query('')

DATE_RANGE = pd.date_range('2018-07-15', '2018-09-30')


def main():
    for date in DATE_RANGE:
        cnx.execute(INSERT_QUERY.format(ingest_date=date))


if __name__ == '__main__':
    main()
    exit()