Summary: Instructions about granting Azure access, including creating a user and assigning roles.
You can set up access to Azure in just a few simple steps.
First, create the credentials for Alooma. Log in to the SQL server on which the Azure warehouse is located and create a login by executing the following command (replacing the text in
<> with the correct value). You can specify a different name for the login, but if you do, be sure to use that login name in the rest of the instructions:
CREATE LOGIN aloomalogin WITH PASSWORD = '<password>';
Next, provide privileges and an initial default schema for the credentials that were just created. Go to your target Azure data warehouse and run the following queries, again replacing the text in
<> with the correct value:
CREATE USER alooma for login aloomalogin; EXEC sp_addrolemember 'db_datareader','alooma'; EXEC sp_addrolemember 'db_datawriter','alooma'; EXEC sp_addrolemember 'db_ddladmin','alooma'; GRANT CREATE TABLE TO alooma; GRANT INSERT TO alooma; GRANT DELETE TO alooma; GRANT UPDATE TO alooma; GRANT CONTROL TO alooma; CREATE SCHEMA <schema>;
And finally, you'll need to make sure you have a master key in the database. If you don’t, go to your target Azure data warehouse and run:
CREATE MASTER KEY;
The first line creates a user for the login through which we'll actually do our actions.
Lines 2-4 grant Alooma access to read, write and change schemas on the database.
Lines 5-8 grant Alooma specific permissions needed.
Line 9 grants Alooma the ability to create credential objects and connect to external data sources (which we need for our copies).
Line 10 creates the default schema Alooma will work with.
That's it. You're done configuring access. Next step is connecting to Azure.