_cloud-connect-service.md

import NotAvailableFreePlan from "versionContent/_partials/_not-available-in-free-plan.mdx";

1. Check your $SERVICE_SHORT is running correctly

   In $CONSOLE, check that your $SERVICE_SHORT is marked as Running.

   

2. Connect to your $SERVICE_SHORT

   Connect using data mode or SQL editor in $CONSOLE, or psql in the command line:

   1. In $CONSOLE, toggle Data.

   2. Select your $SERVICE_SHORT in the connection drop-down in the top right.

      

   3. Run a test query:

      SELECT CURRENT_DATE;

      This query gives you the current date, you have successfully connected to your $SERVICE_SHORT.

   And that is it, you are up and running. Enjoy developing with $COMPANY.

   1. In $CONSOLE, select your $SERVICE_SHORT.

   2. Click SQL editor.

      

   3. Run a test query:

      SELECT CURRENT_DATE;

      This query gives you the current date, you have successfully connected to your $SERVICE_SHORT.

   And that is it, you are up and running. Enjoy developing with $COMPANY.

   1. Install psql.

   2. Run the following command in the terminal using the service URL from the config file you have saved during service creation:

      psql "<your-service-url>"
      

   3. Run a test query:

      SELECT CURRENT_DATE;

      This query returns the current date. You have successfully connected to your $SERVICE_SHORT.

   And that is it, you are up and running. Enjoy developing with $COMPANY.

Quick recap. You:

• Manage your $SERVICE_SHORTs in the $OPS_MODE in $CONSOLE: add $READ_REPLICAs and enable high availability, compress data into the $COLUMNSTORE, change parameters, and so on.
• Analyze your data in the $DATA_MODE in $CONSOLE: write queries with autocomplete, save them in folders, share them, create charts/dashboards, and much more.
• Store configuration and security information in your config file.