{"repo":"aws-samples/aws-lambda-clickhouse","free":true,"listed":false,"github":"https://github.com/aws-samples/aws-lambda-clickhouse","clone":"git clone https://github.com/aws-samples/aws-lambda-clickhouse.git","description":"Run the open-source online analytics database ClickHouse in an AWS Lambda function","language":"TypeScript","stars":79,"topics":["aws","aws-lambda","clickhouse","serverless"],"license":"MIT-0","category":"databases-storage","readme_excerpt":"ClickHouse in AWS Lambda This sample shows how to run the open-source online analytics database ClickHouse in an AWS Lambda function. It enables ad-hoc querying of existing data in Amazon S3 buckets with ClickHouse SQL using a simple HTTP client, without the need to run clickhouse-local on your computer or to deploy a ClickHouse cluster. The sample can also help to build other serverless solutions around ClickHouse query engine. Quick start 1. Have docker and AWS Command Line Interface (AWS CLI) installed and configured. 1. Clone the repo. 1. Install and bootstrap AWS Cloud Development Kit (AWS CDK) - more details here. 1. Install dependencies. 1. Set USER ARN environmental variable to the Amazon Resource Name (ARN) of the AWS IAM user that will be granted permission to run queries. To set it to your default AWS CLI user: 1. Deploy the stack to your AWS account. 1. See the TestUrl output in AWS CDK console output. It references a test file in the S3 bucket created during deployment. E.g. 1. Issue an HTTP POST request signed with AWS Signature Version 4 to this URL. Pass your SQL statement as a plain text in the request body. Use a pre-defined name table in all SQL statemetns. For example, with curl: Or use Postman for graphical UI. 1. Get your query execution results in the HTTP response body Check the guide for more querying options. Architecture The sample includes a Lambda Function with the Lambda Function URL enabled, an IAM user identity policy, a Lambda function executi","default_branch":null,"files":null,"tree":[],"storefront":"/r/aws-samples","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/aws-samples/aws-lambda-clickhouse/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}