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

CREATE TABLE Students(
	student_number	INT AUTO_INCREMENT PRIMARY KEY,
	student_name	VARCHAR(100),
	dept_name		VARCHAR(100),
	subject			VARCHAR(100),
	marks			INT
);

INSERT INTO Students (student_name,dept_name,subject,marks) VALUES
('Tom','CS','Programming',90),

aveek22

aveek22

# Import the pandas
import pandas as pd

# Read the CSV file
data = pd.read_csv('C:/DemoSourceData.csv')

# Print the data
print(data)

aveek22

CREATE TABLE laptops(
	laptop_id		SERIAL,
	laptop_name		VARCHAR(100),
	laptop_brand	VARCHAR(100),
	relesed_year	INT,
	device_type		VARCHAR(100),
	price			DECIMAL(9,2)
);

INSERT INTO laptops (laptop_name,laptop_brand,relesed_year,device_type,price) VALUES

aveek22

CREATE TABLE Laptops(
	LaptopID		INT IDENTITY(1,1) PRIMARY KEY,
	LaptopName		VARCHAR(100),
	LaptopBrand		VARCHAR(100),
	ReleasedYear	INT,
	DeviceType		VARCHAR(100),
	Price			DECIMAL(9,2)
)
GO

aveek22

/*
	This script will alter the users table on the flyway-db database
	and add a few columns
*/

ALTER TABLE Users ADD  [Age]	INT;
ALTER TABLE Users ADD  [Email]	VARCHAR(255);
GO

aveek22

/*
	This script will create the users table on the flyway-db database
*/

CREATE TABLE Users(
	[UserID]	INT,
	[UserName]	VARCHAR(255),
	[Address]	VARCHAR(255),
)
GO

aveek22

{
    "id": "1",
    "productName" : "Samsung Galaxy Mobile",
    "productCategory" : "Electronics",
    "totalPrice" : 1000
},
{
    "id": "2",
    "productName" : "Mercedes Benz",
    "productCategory" : "Automobile",

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,