def test_create_fields_has_columns(config):
del config["datasources"]["testdb2"]
table_config = config["datasources"]["testdb1"]["tables"]["main.partners"]
table_config["create_fields"] = True
wh = Warehouse(config=config)
assert wh.has_dimension("partner_id")
assert wh.has_dimension("partner_name")
assert not wh.has_dimension("partners_name")
# This one is auto-generated with create_fields, so it has a default naming
# style:
assert wh.has_dimension("main_partners_created_at")
def test_warehouse_remote_json_table(adhoc_config):
url = (
"https://raw.githubusercontent.com/totalhack/zillion/master/tests/dma_zip.json"
)
adhoc_config["datasources"]["test_adhoc_db"]["tables"]["main.dma_zip"][
"data_url"] = url
wh = Warehouse(config=adhoc_config)
assert wh.has_dimension("Zip_Code")
def test_warehouse_remote_google_sheet(adhoc_config):
url = "https://docs.google.com/spreadsheets/d/1iCzY4av_tinUpG2Q0mQhbxd77XOREwfbPAVZPObzFeE/edit?usp=sharing"
adhoc_config["datasources"]["test_adhoc_db"]["tables"]["main.dma_zip"][
"data_url"] = url
wh = Warehouse(config=adhoc_config)
assert wh.has_dimension("Zip_Code")
def test_warehouse_remote_csv_table(adhoc_config):
table_config = adhoc_config["datasources"]["test_adhoc_db"]["tables"][
"main.dma_zip"]
table_config["adhoc_table_options"] = {"nrows": 30}
wh = Warehouse(config=adhoc_config)
assert wh.has_dimension("Zip_Code")
