You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Please enable the MetaData.reflect function in dlt to include views by default when accessing database resources. Currently, views are not included by default, requiring additional steps to configure, leading to potential oversight.
Are you a dlt user?
Yes, I run dlt in production.
Use case
When extracting and loading views from a SQL database, users need to manually enable view inclusion by setting MetaData.reflect(bind=engine, views=True) method. This additional step can be overlooked and is not initially intuitive.
Proposed solution
Modify the default behavior of the MetaData object to include views by default by setting views=True in the MetaData.reflect method. This would streamline processes for users who manage databases and want to load views.
Related issues
No response
The text was updated successfully, but these errors were encountered:
dat-a-man
changed the title
Enable Default Inclusion of Views in MetaData Object (SQL database)
Enable default inclusion of views in MetaData object (SQL database)
May 11, 2024
Feature description
Please enable the
MetaData.reflect
function in dlt to include views by default when accessing database resources. Currently, views are not included by default, requiring additional steps to configure, leading to potential oversight.Are you a dlt user?
Yes, I run dlt in production.
Use case
When extracting and loading views from a SQL database, users need to manually enable view inclusion by setting
MetaData.reflect(bind=engine, views=True)
method. This additional step can be overlooked and is not initially intuitive.Proposed solution
Modify the default behavior of the MetaData object to include views by default by setting views=True in the MetaData.reflect method. This would streamline processes for users who manage databases and want to load views.
Related issues
No response
The text was updated successfully, but these errors were encountered: