Cloudera Docs

Exporting SQL projects

You can use source control to create a backup from your SSB projects. After the upgrade is successful, you can import the projects on Streaming SQL Console.

  1. Navigate to the Streaming SQL Console.
    1. Go to your cluster in Cloudera Manager.
    2. Select SQL Stream Builder from the list of services.
    3. Click SQLStreamBuilder Console.
      The Streaming SQL Console opens in a new window.
  2. Open a project from the Projects page of Streaming SQL Console.
    1. Select an already existing project from the list by clicking the Open button or Switch button.
    2. Create a new project by clicking the New Project button.
    3. Import a project by clicking the Import button.
    You are redirected to the Explorer view of the project.
  3. Click Source Control.
    You can configure the source control settings with the following steps, if the source control is not configured yet:
    1. Add a remote Github repository URL to the Clone URL field.
      You can use the following example URLs with or without authentication:
      • To clone without authentication: https://github.com/cloudera/ssb-examples.git
      • To clone and push with HTTP basic authentication (username/password): https://github.com/cloudera/ssb-examples.git

        In case of using basic authentication, the personal access token needs to be provided as password. For more information about creating personal access tokens, see the Github documentation.

      • To clone and push with SSH authentication (SSH private key): git@github.com:cloudera/ssb-examples.git
        In case of using SSH authentication, you need to generate the private key using the following command:
        ssh-keygen -t ecdsa -b 256 -m pem -C "name@example.com"
        As not every SSH private key is supported, you can use the following command to convert your key to the acceptable format:
        ssh-keygen -m pem -p -f [***PATH_TO_PRIVATE_KEY***]
      • To clone and push a local git repository on the filesystem of SSB host: file:///usr/src/ssb-examples/
    2. Provide the branch name or tag of the Github repository to the Branch field. This branch is checked out when pulling or pushing to the Github repository.
  4. Provite a commit message.
  5. Click Push.
  6. Review that the commit appears in the repository you pushed the change.