When you click the "TEST" button, Silota will create a SSH tunnel to your bastion host and try connecting to your database. These credentials are different from your database credentials. Pick the "Connect to a private network" option and enter the bastion hostname, username ("silota" in this case) and the port for the SSH tunnel. Step 3: Connect via the private network option Paste the above public key in the file /home/silota/.ssh/authorized_keys as a new line. Make sure there's no password because we use public-key authentication. Step 1: Download our public keyĪdd our public key to your bastion host: ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAACAQC7Q9FkSSWx3IUNXiWZB5eq28/V1o24IbUnOZlpxGpG7jn3kY1j7ocJIDGIvtjWFv2MfyVtHRq7RG99tV3q7bo0KHCKe3VbLR5/NQfo9BYHoa1bg38lzYAwPOd4GT6chqy7M/7o5OCMawyec4RtaM9bYSPQxnpZi6vWST/vjjXsfGckUYGhUWIpVbaAUYCeuszq1EvvC3dVue1i8Fl5TYOK3tSLrYAM8aApyd2++qTOZht+0PoyP4JtT2MyuPSAP068Zyr0NskzbU/86ybMQVGTRI/y/7+K6gC0kr1f+Zy9LFMMKuq1wPx+FexTemXrgUwQO1IGqcdlpEid0f5Zb5EW6jIcBA5uftmo9RdcP5bYvRjPojvLlOOL+APMVwnpsMb+eSmORT0t0j8HeH/HKQdBLRDeexTBHXvCyMhG20DR4KEowmMV5ezLTMolxcBGJ03Tzixx2XuXCLve9ca/LjzqtAjT6AgmkOtIwVIiatyFuPkSjdl6jGYzjSTL2tWHUA3SU8LO49tpg66jLlRmQrwgZfv4dbhWavbuuaKgvoLMcB4QXJAhoIffCCWZh8koJb2ZLt7OvPh2+fpC4L+kh8WrtumpiIcfhwIY0lPrPfbM8pCZmrc4QANR4GybFOUHV6DKdXW90jCla1ljNRdwWSASm7XcLbSM7afC0ZjfIizHkQ= 2: Add a user to the bastion hostĬreate a user account "silota" to the bastion host for us to connect to. If your database is on a private network, like inside a VPC and doesn't have a publically routable IP address for us to connect, you can setup a bastion host for us to connect through. Using AWS Athena to understand your AWS billsĬanada Province & Census Division ShapefilesĬonnect to a private network with an SSH Tunnel Modeling: Denormalized Dimension Tables with Materialized Views for Business Users Gap analysis to find missing values in a sequenceĮstimating Demand Curves and Profit-Maximizing Pricing Querying JSON (JSONB) data types in PostgreSQL Using SQL to analyze Bitcoin, Ethereum & Cryptocurrency Performance Multichannel Marketing Attribution ModelingĪnalyzing Net Promoter Score (NPS) surveys in SQL to improve customer satisfaction & loyalty SQL's NULL values: comparing, sorting, converting and joining with real values ![]() SQL Server: Date truncation for custom time periods like year, quarter, month, etc.įilling Missing Data & Plugging Gaps by Generating a Continuous Seriesįinding Patterns & Matching Substrings using Regular ExpressionsĬoncatenating Rows of String Values for Aggregation Redshift: Generate a sequential range of numbers for time series analysis MySQL: Generate a sequential range of numbers for time series analysis ![]() Understanding how Joins work – examples with Javascript implementation First steps with Silota dashboarding and chartingĬalculating Exponential Moving Average with Recursive CTEsĬalculating Difference from Beginning RowĬreating Pareto Charts to visualize the 80/20 principleĬalculating Summaries with Histogram Frequency DistributionsĬalculating Relationships with Correlation MatricesĪnalyzing Recency, Frequency and Monetary value to index your best customersĪnalyze Mailchimp Data by Segmenting and Lead scoring your email listĬalculating Top N items and Aggregating (sum) the remainder into "All other"Ĭalculating Linear Regression Coefficientsįorecasting in presence of Seasonal effects using the Ratio to Moving Average method
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |