Forum Discussion

kusto345's avatar
kusto345
Copper Contributor
Feb 18, 2020

How do I use Kusto client to create table?

I am trying to automate provisioning of Kusto cluster. So far I have terraform to create the cluster, create the database. I have yet to find a way to create a table.    I went down the path of usi...
Azure Data Explorer (Kusto)
Kusto language
Daniel Dubovski's avatar
Daniel Dubovski
Icon for Microsoft rankMicrosoft
Mar 01, 2020

kusto345 , The error does suggest that you are missing adal. 
It may be because you are working on a different environment where adal is missing (virtualenv, conda, etc..) or that you have an old version installed.

Could you kindly paste the output of pip freeze, and try and import adal in python REPL?

  • kusto345's avatar
    kusto345
    Copper Contributor
    Mar 08, 2020

    Daniel Dubovski thanks for responding and the pointer, apologies that it took me so long to respond.

     

    I cleaned up my env and recreated it. I seem to have made progress but still unable to use the client sdk to create a table

     

    'message': 'Caller is not authorized to perform this action', '@type': 'Kusto.DataNode.Exceptions.UnauthorizedDatabaseAccessException', '@message': "Principal 'aadapp=<sp>;<tenant-id>' is not authorized to access database '<database-name>'."

     

    So I turned to azure cli to grant the role of "AllDatabasesAdmin" to my service principal. I however do not see any of the roles for ADX. As a result when I try to grant my sp access to the database it just does not find the role. I picked a role from the portal, there are two "AllDatabasesAdmin" and "AllDatabasesViewer"

     

    az role assignment create --assignee <sp> --scope <resource-path-to-database> --role AllDatabasesAdmin.

     

    I get the following exception 

    Role 'AllDatabasesAdmin' doesn't exist.

     

Resources