search

CityOfLosAngeles / aqueduct

A shared pipeline for building ETLs and batch jobs that we run at the City of LA for Data Science Projects. Built on Apache Airflow & Civis Platform
Apache License 2.0
21 stars 6 forks source link

Load PCTS #343

Open ian-r-rose opened 4 years ago

ian-r-rose commented 4 years ago

We want to schedule regular ingests of PCTS into Civis.

ian-r-rose commented 4 years ago

Working with David Terukina at planning to load PCTS into Civis. We are currently blocked by networking rules on the Azure PCTS database. Connecting to an on-prem SQL Server works as expected, but the cloud instance fails. I can ping the server, but an unable to connects via ODBC.

ian-r-rose commented 4 years ago

I am also unable to connect from Civis, and in that case I cannot ping either