I have two workspaces. I created Kusto database tables in the first workspace and Warehouse tables in the second workspace. Could you please help me copy the data from the Kusto tables into the Warehouse tables using the .export sql option? Any assistance would be greatly appreciated.
Hi Will I can able to use this .export async to sql <table_name> h@"Server=tcp:<worksapceid>.datawarehouse.fabric.microsoft.com; Database=whs_silver_aru; Authentication=ActiveDirectoryDefault; Encrypt=True;TrustServerCertificate=False;" <| <KQL Table_name> Authentication=ActiveDirectoryInteractive Authentication=ActiveDirectoryManagedIdentity Authentication=ActiveDirectoryDefault i am getting this error "State": Failed, "Status": Could not login because the authentication failed., please let me know how i can resolve this issue?