Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi, Team
We can see Mirrored database, SQL analytics endpoint and SQL analytics endpoint in type of filter.
I can filter only mirrored databases by clicking Mirrored Databases in the filter type.
If I click on one of the SQL Analytics endpoints, I can see that only mirrored databases are filtered.
So that should be delete one of one of SQL analytics endpoint.
Thanks,
Hong
Solved! Go to Solution.
Hi @Hongju_Jung
In a scenario where a Mirrored database and a Lakehouse coexist, the system automatically generates two SQL analytics endpoints. One endpoint corresponds to the mirrored database, and the other caters to the Lakehouse data. As illustrated in the previously shared screenshots, this behavior is expected.
I hope this information helps.
Thank you.
Hi, @v-cboorla-msft
Thank you for your response.
We can see 2 SQL analytics endpoints showing different filter results..
Is that by design?
Thanks,
Hong
Hi @Hongju_Jung
In a scenario where a Mirrored database and a Lakehouse coexist, the system automatically generates two SQL analytics endpoints. One endpoint corresponds to the mirrored database, and the other caters to the Lakehouse data. As illustrated in the previously shared screenshots, this behavior is expected.
I hope this information helps.
Thank you.
Hi @Hongju_Jung
Glad that you query got resolved.
Please continue using Fabric Community for further queries.
Thanks.
Hi @Hongju_Jung
Thanks for using Microsoft Fabric Community.
Mirroring creates three items in your Fabric workspace:
Each mirrored Azure SQL database has an autogenerated SQL analytics endpoint that provides a rich analytical experience on top of the Delta Tables created by the mirroring process. Users have access to familiar T-SQL commands that can define and query data objects but not manipulate the data from the SQL analytics endpoint, as it's a read-only copy.
I have filtered the Mirrored database and SQL analytics endpoint (autogenerated while creating Mirrored database).
You can see the similar behaviour when I filter for Lakehouse and SQL analytics endpoint (autogenerated while creating Lakehouse)
I hope this information helps. Please do let us know if you have any further queries.
Thank you.
Check out the October 2024 Fabric update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
3 | |
2 | |
1 | |
1 | |
1 |