Breaking News: Grepper is joining You.com. Read the official announcement!

set up nginx

RM answered on October 2, 2024 Popularity 9/10 Helpfulness 1/10

answer set up nginx

related snowflake etl

set up nginx

Comment

1. edit the nginx-{{version}}\conf\nginx.conf
    server {
        listen       80;
        server_name  portal-test.com.ph;

        location / {
        	# your frontend
            proxy_pass http://localhost:8081;
        }

        location /api {
            # your backend
            # make sure all the routes starts in "/api"
            proxy_pass http://localhost:3000;
        }
        
2. edit C:\Windows\System32\drivers\etc\hosts
	(open that file in vscode)
	in last line add your local ip followed by the server_name in nginx.conf
    example: 
    192.168.120.89 portal-test.com.ph
    (save as admin)
          
3. start nginx
   (make sure that theres only one instance of nginx in your Task Manager)
   (if more than one, you need to end all the nginx and start again)
   (if you modify the nginx-{{version}}\conf\nginx.conf file make sure to restart the nginx)
   commands:
   open terminal inside nginx{{version}} folder
   To start nginx (windows): 
       start .\nginx.exe
   To quit nginx:
       .\nginx.exe -s quit
       .\nginx.exe -s stop
   To restart nginx:
       .\nginx.exe -s reload
       
4. now you can go to browser and the url http://portal-test.com.ph can now
   listening in your backend and frontend

Popularity 9/10 Helpfulness 1/10 Language whatever

Source: Grepper

Tags: config nginx nginx-config set whatever

Link to this answer
Share Copy Link

Contributed on Oct 02 2024

0 Answers Avg Quality 2/10

Closely Related Answers

snowflake etl

Comment

# On snowflake, you use ELT instead of ETL
# First you extract data, then you load the data on snowflake, and finally do Transformation inside snowflake

# install necessary packages: pip install snowflake-connector-python pandas
import snowflake.connector


# EXTRACT : Use pd.read_csv, pd.read_parquet, pd.read_json
df = .....

# LOAD : Load the data from your PC (eg: your desktop RDBMS like postgreSQL) to Snowflake account
from sqlalchemy import create_engine

def snowflake_engine(username, password, account_url, warehouse_name, db_name, schema_name):
    engine = create_engine(URL('snowflake',
                                user = username,
                                password = password,
                                account = account_url,
                                warehouse = warehouse_name,
                                database = db_name,
                                schema = schema_name))
    return engine

engine = snowflake_engine('USERNAME', 'PASSWORD', 'ACCOUNTURL', 'WAREHOUSE', 'DATABASE', 'SCHEMA') # Create the engine
df.to_sql('table_name', con=engine, index=False, if_exists='append') # Use the engine to load data into Snowflake

# TRANSFORM : Perform Transformation on warehouse

def warehouse_connection(username, password, account_url, warehouse_name, db_name, schema_name):
    connection = snowflake.connector.connect(
        user = username,
        password = password,
        account = account_url,
        warehouse = warehouse_name,
        database = db_name,
        schema = schema_name
    return connection
)

con = warehouse_connection('USERNAME', 'PASSWORD', 'ACCOUNTURL', 'WAREHOUSE', 'DATABASE', 'SCHEMA') # Establish a connection to the Snowflake data warehouse

def transform(query, connnection=con):
    connnection.cursor().execute(query)


my_query = """
CREATE OR REPLACE TABLE transformed_data AS
SELECT column1, SUM(column2) 
FROM raw_data 
GROUP BY column1;
"""
transform(my_query)

Popularity 7/10 Helpfulness 1/10 Language python

Source: dev.to

Tags: etl whatever

Link to this answer
Share Copy Link

Contributed on Oct 02 2024

Innocent Iguana

0 Answers Avg Quality 2/10

set up nginx

Contents

More Related Answers

set up nginx

Closely Related Answers

snowflake etl

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.