Guen Prawiroatmodjo guenp

Design Doc Title

Stakeholders

List stakeholders for project/feature.

Role	Person
Dev Owner
Other Dev 1 (Engine)

dbt-example-motherduck

Prerequisites

This example requires Poetry. You can use pipx with pipx install poetry to install it. For further instructions, see docs.

Instructions

To get started with a sample project using dbt and MotherDuck, first create and activate a new Python environment using Poetry.

"A Duck in the hand is worth two in the Cloud: Data preparation and analytics on your laptop with DuckDB" demo

Link to slides

This is the code used for the demo.

To download the EBD data, go to https://ebird.org/data/download/ebd.

To create a new virtual environment and install the dependencies, run

Grover's algorithm

Grover's search algorithm.

A fast quantum mechanical algorithm for database search

Windows SSH Server with Password-less Key Authentication and Default WSL2 Shell

Disclaimer: I am not a Windows Admin and I'm not even that good with PowerShell.

I wanted to be able to SSH into my Windows laptop directly into Linux. I also wanted to disable password authentication and only allow public key (RSA in my case) authentication.

Scott Hanselman wrote a blog post on how to make your default WSL2 distro your default shell for SSH. Windows OS Hub published an article on using public key

	import threading
	from duckdb import DuckDBPyConnection

	# from duckdb_provider.hooks.duckdb_hook import DuckDBHook
	import duckdb

	SHARE_URI = "md:_share/s2/7564f992-2f93-4799-bce2-1637445b2881"
	DB_PATH = "md:"

	{
	"qubits": [
	{
	"id": 0,
	"numChildren": 1
	},
	{
	"id": 1,
	"numChildren": 1
	},

	# This uses the latest Docker image built from the samples repository,
	# defined by the Dockerfile in Build/images/samples.
	FROM mcr.microsoft.com/quantum/samples:latest

	# Mark that this Dockerfile is used with the samples repository.
	ENV IQSHARP_HOSTING_ENV=SAMPLES_HOSTED

	# Make sure the contents of our repo are in ${HOME}.
	# These steps are required for use on mybinder.org.
	USER root

	RUN apt-get update && apt-get install -y openssh-server
	RUN mkdir /var/run/sshd

	ARG DOCKER_SSH_PASS

	RUN echo "root:${DOCKER_SSH_PASS}" \| chpasswd
	RUN sed -i 's/#PermitRootLogin prohibit-password/PermitRootLogin yes/' /etc/ssh/sshd_config

	# SSH login fix. Otherwise user is kicked off after login
	RUN sed 's@session\srequired\spam_loginuid.so@session optional pam_loginuid.so@g' -i /etc/pam.d/sshd

	license: gpl-3.0
	height: 600
	redirect: https://observablehq.com/@d3/d3-force-directed-graph