Hi there I need to push a geojson file to Postgres PostGIS W

Question

Hi there I need to push a geojson file to Postgres PostGIS What is the most efficient way to do this One option is to write a shell command using ogr2ogr within a task Is there a recommended way to do this

Dean Magee · Answer

FYI ive tried using Geopandas to postgis method but that is way too slow

Andrew Huang · Answer

Perhaps using the collection prefect shell if you need to write a shell command within a task