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.
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