aveek22

DROP TABLE IF EXISTS SQLShackGeomTest;

CREATE TABLE SQLShackGeomTest (
	sensor_id VARCHAR(50) PRIMARY KEY NOT NULL,
	longitude VARCHAR(50),
	latitude VARCHAR(50),
	country TEXT,
	sensorTemp INTEGER,
	sensorPressure INTEGER,
	sensorTime TIMESTAMP,

aveek22

CREATE TABLE public.mumbai_house_price_raw
(
    id bigint,
    city text COLLATE pg_catalog."default",
    locality text COLLATE pg_catalog."default",
    bedroom_num bigint,
    latitude double precision,
    longitude double precision,
    post_date timestamp without time zone,
    price bigint,

aveek22

{
  "etl_tstamp": "2023-09-01T13:00:03.635Z",
  "dvce_ismobile": false,
  "br_version": "1410.0.3",
  "v_collector": "ssc-2.9.1-kinesis",
  "collector_tstamp": "2023-09-01T13:00:03.288Z",
  "os_family": "Mac OS X",
  "event_vendor": "com.google.analytics",
  "network_userid": "46904ea5-9d30-4d4f-899b-fc6a052ad118",
  "br_renderengine": "OTHER",

aveek22

EXEC master.dbo.sp_addlinkedserver 
	@server =N'AWS_ATHENA', 
	@srvproduct=N'', 
	@provider=N'MSDASQL', 
	@datasrc=N'AWS_ATHENA'
GO

EXEC master.dbo.sp_addlinkedsrvlogin 
	@rmtsrvname=N'AWS_ATHENA', 
	@useself=N'False', 

aveek22

variable "bucket_name" {}

resource aws_s3_bucket "tf_multi_workspace_bucket" {
  bucket = var.bucket_name
}

aveek22

locals {
  bucket_name = "tf-multi-account-test-1234-${terraform.workspace}"
}

module "s3_bucket_dev" {
  source = "./modules/s3"
  count = terraform.workspace == "dev" ? 1 : 0
  providers = {
    aws = aws.dev
  }

aveek22

terraform {
  required_version = "1.1.9"
  required_providers {
    aws = {
      source  = "hashicorp/aws"
      version = "> 4.26.0"
    }
  }
}

aveek22

Terraform used the selected providers to generate the following execution plan. Resource actions are indicated with the following symbols:
  + create

Terraform will perform the following actions:

  # module.s3_main_bucket.aws_s3_bucket.main_bucket will be created
  + resource "aws_s3_bucket" "main_bucket" {
      + acceleration_status         = (known after apply)
      + acl                         = (known after apply)
      + arn                         = (known after apply)

aveek22

Terraform used the selected providers to generate the following execution plan. Resource actions are indicated with the following symbols:
  + create

Terraform will perform the following actions:

  # module.s3_dependent_bucket.aws_s3_bucket.dependent_bucket will be created
  + resource "aws_s3_bucket" "dependent_bucket" {
      + acceleration_status         = (known after apply)
      + acl                         = (known after apply)

aveek22

resource "aws_s3_bucket" "dependent_bucket" {
  bucket = "dependent-bucket-00721"
  tags = {
    "Name" = "Dependent Bucket"
    "Environment" = "Test"
  }
}