frictionlessdata / datapackage

Data Package is a standard consisting of a set of simple yet extensible specifications to describe datasets, data files and tabular data. It is a data definition language (DDL) and data API that facilitates findability, accessibility, interoperability, and reusability (FAIR) of data.
https://datapackage.org
The Unlicense
481 stars 107 forks source link

Add `dialect.table` for selecting tables in SQL databases #920

Closed khusmann closed 4 weeks ago

khusmann commented 2 months ago

As mentioned in https://github.com/frictionlessdata/specs/issues/901, we have dialect.sheetName for selecting spreadsheets, but no dialect.table for selecting tables in an SQL db.

fjuniorr commented 1 week ago

@roll, I'm not sure if there's still time, but wouldn't it make sense to add a dialect.namespace to specify the database schema where the table is located?

frictionless-py for example already allows this.