Alex Ott alexott

This gist contains Terraform code that allows to synchronize groups & users from AAD into the Databricks workspace, without need to setup SCIM connector.

This is an extended version of initial synchronizer implemented by Serge.

To start, download all .tf files to some place, and create a file terraform.tfvars with following content:

groups = {
 "My AAD group" = {

Built statements

Built statements are generated via [QueryBuilder]'s Fluent API. Use of Fluent API allows easier build of the complex queries, comparing with hardcoding the CQL statements into the source code.

Note: The provider builders perform very little validation of the built query. There is thus no guarantee that a built query is valid, and it is definitively possible to create invalid queries.

	@startuml

	hide footbox

	participant "Client" as client
	database "Coordinator DSE node" as cnode
	database "Batchlog DSE nodes" as bnode
	database "DSE Nodes" as onode

	alt successful case

	cqlsh:test> describe test.abc6

	CREATE TABLE test.abc6 (
	id int PRIMARY KEY,
	c counter
	);

	cqlsh:test> select * from test.abc6;

	id \| c

	>curl -L -O "https://dl.bintray.com/thelastpickle/tlp-tools-tarball/tlp-stress-1.0.0.tar"
	% Total % Received % Xferd Average Speed Time Time Time Current
	Dload Upload Total Spent Left Speed
	0 0 0 0 0 0 0 0 --:--:-- 0:00:01 --:--:-- 0
	100 22.5M 100 22.5M 0 0 3641k 0 0:00:06 0:00:06 --:--:-- 4985k
	>tar xvf tlp-stress-1.0.0.tar
	x tlp-stress-1.0.0/
	x tlp-stress-1.0.0/lib/
	...
	>cd tlp-stress-1.0.0

	ARG DSE_VERSION=6.7.0
	FROM datastax/dse-server:${DSE_VERSION}

	ARG Z_VERSION="0.8.0"
	ENV Z_HOME="/zeppelin"

	ARG Z_URL_PREFIX=http://archive.apache.org/dist/zeppelin/zeppelin-${Z_VERSION}
	ARG Z_TARBALL=zeppelin-${Z_VERSION}-bin-all.tgz
	ARG Z_DOWNLOAD_URL=${Z_URL_PREFIX}/${Z_TARBALL}

	from dse.cluster import Cluster
	import sys
	import json

	if (len(sys.argv) < 3):
	print("Usage: generate.py contact_point file_name")
	exit(1)

	cluster = Cluster([sys.argv[1]])
	session = cluster.connect()