Forum Discussion
Copy Job, Database Table Listing Problem
verianalizi, my apologies here as above mentioned can be achived from data factory pipelines.
can you please confirm once you have given connection details and click next, it should list all the tables like show below.
as you mentioned issue with listing huge number of tables, this might be due to limitations that is mentioned in Fabric documentation here. PFB screenshot for same.
additionally, below copy job is in preview mode and i request you to please submit your feedback in documentation. your input is valuable and will help other users who might have similar questions. We appreciate your effort in sharing your thoughts
What is Copy job (preview) in Data Factory - Microsoft Fabric | Microsoft Learn
Thanks,
Prashanth Are
MS Fabric community support.
Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a "Kudos"
Community SupportHi verianalizi,
Thanks for reachoing Microsoft Fabric community Support.
Here are a few potential solutions you could try to handle this issue:
- Limit the Table List: instead of attempting to display all tables at once, limit the number of tables shown. You can filter or sort the list based on specific criteria (e.g., table names, schemas, or metadata).
Use SQL queries like:
SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME LIKE 'YourPattern%' -- or other filtering conditions
ORDER BY TABLE_NAME
- Use Specific Table Names: If you're only interested in certain tables, directly reference the table names in your queries instead of trying to retrieve a list of all tables.
For example: SELECT * FROM YourTableName
Thanks,
Prashanth Are
MS Fabric community support.
Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a "Kudos"
Hello,
As you can see there is no such an option.
- v-prasare
verianalizi, my apologies here as above mentioned can be achived from data factory pipelines.
can you please confirm once you have given connection details and click next, it should list all the tables like show below.
as you mentioned issue with listing huge number of tables, this might be due to limitations that is mentioned in Fabric documentation here. PFB screenshot for same.
additionally, below copy job is in preview mode and i request you to please submit your feedback in documentation. your input is valuable and will help other users who might have similar questions. We appreciate your effort in sharing your thoughts
What is Copy job (preview) in Data Factory - Microsoft Fabric | Microsoft Learn
Thanks,
Prashanth Are
MS Fabric community support.
Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a "Kudos"
