Table of Contents

Tellius Copilot 101

Ramya Priya Updated by Ramya Priya

Welcome to Copilot 101, the comprehensive guide designed to help you get the most out of Tellius Copilot. In this page, we provide an overview of Tellius Copilot and its features, followed by step-by-step instructions to help you get started, and concludes with best practices and FAQs.

What is Tellius Copilot?

Tellius Copilot enriches the platform's already existing augmented analytics capability with GPT to simplify your workflow, minimize labor time, and automate time-intensive, laborious tasks.

Think of Tellius Copilot as your assistant (or copilot), who does the following tasks for you:

  • Create SQL/Python code
  • Find and fix errors in code
  • Add more context to the code (with comments and explanations)
  • Generate display names, synonyms, and descriptions for columns

How do I turn on Tellius Copilot?

  1. Click on the user icon in the bottom right corner.
  2. Navigate to Settings → Application Settings → Copilot.
  3. Click on the toggle near Enable Tellius Copilot to turn on Copilot on your Tellius instance.
  1. A popup window will appear requesting you to read the terms and conditions before enabling. 
  1. Before using Copilot, it is important to read the terms and conditions to understand the guidelines regarding the use of the service. Once you have reviewed the terms, you can click on Agree.
  2. Now, you can enjoy the benefits of GPT-powered Tellius Copilot.

What can Tellius Copilot do?

As outlined earlier, Tellius Copilot can help you in

  • Generating and validating code
  • Generating metadata

Generating and validating code

Instead of going through each line of code to find and fix errors or writing elaborate code for specific use cases from scratch, you can now ask Tellius Copilot to perform those tasks for you.

Create SQL/Python code

  1. Navigate to Data → Prepare and select the required dataset on the left pane.
  2. Under Data tab, click on Edit and choose SQL or Python as required.
  1. If you choose Python (for example), you will get the following window where you can choose from the already available code library, or create code from scratch.
  2. Click on Generate with AI to let Copilot generate the code for you.
  1. Start typing your prompt in the box “Ask AI to generate code” and click on Generate button.
  2. The required code will be generated under Generated code section. Click on Apply code to copy-paste the code to the editor above.
  1. Alternatively, if you want to write code but use Copilot to validate your code, then click on Edit with AI button at the top right corner. The following options will be displayed.
Find errors

Click on Find errors to check the code for any possible errors. Copilot will display the corrected code in the section Find errors. Click on Fix errors to copy-paste the refined version to the editor.

Comment each line of code

To add more context to the code, click on Comment each line of code. Copilot will add inline comments in the section Add comments. Click on Apply comments to copy-paste the comments to the editor.

Add explanation

To add summarized explanations to the code, click on Add explanation. In the section Add explanation, Copilot will explain the code to make it easily understandable.

  1. Click on Run Validation to verify the code, and click on Save once the code is validated.
To access Copilot's capabilities for your SQL/Python code, click on the Edit with AI button located above the editor whenever required.

Generating metadata

Tellius Copilot can generate metadata—display names, synonyms, descriptions—relevant to each column, irrespective of the number of columns in a dataset.

  1. Navigate to Data → Prepare → Metadata. Choose the required dataset from the left pane and click on Edit.
  2. Metadata can be generated in two ways:
    1. For a single column
    2. For multiple columns (bulk operation)
2 a) For a single column

To generate metadata for a single column, hover over any required column, and the purple wand will appear at the right end. Click on the wand to generate the display name/synonym/description.

2 b) For multiple columns
  1. To generate metadata in bulk, there are a couple of ways in which you can select the required columns.

Option 1:

  • Click on the checkbox present near each column name.
  • The number of columns selected would be displayed under Column Name.

Option 2:

  • Click on Generate with AI button at the right corner below the Data Pipeline. The following menu will be displayed.

  • As required, click on Display name or Synonyms or Description. Another submenu with options “All cells” and “Only empty cells” will be displayed.
    • All cells - Selects all the cells (including the ones which have already been populated).
    • Only empty cells - Selects only the empty cells which haven’t been populated.
  • If one of the above is clicked, then the table columns will be selected accordingly. The number of selected columns is mentioned below the Column name. 
  • Any column can be included/excluded by checking/unchecking the check box respectively.
  1. Once the required columns are selected, click on Generate button under Display name/Synonyms/Description.

  1. For the selected rows, the required metadata will be populated. The suggestions can be accepted in the following two ways:
  • Next to each generated metadata, you can click on ✅ to retain the suggestion or click on ❌ to dismiss it. The suggested metadata can also be edited before accepting.
  • If you are okay with all the suggested display names/synonyms/descriptions, then click on Accept All. To dismiss all the suggestions, click on Discard All.

Tellius Copilot only generates suggestions and recommendations. Ultimately, it is the choice of the users whether to accept, edit, or discard the suggestions. The accepted metadata will be saved only after clicking on Publish.
The suggested metadata will be displayed in purple color. When they are accepted, they turn grey in color. Please note that the suggestions will be retained only if they are accepted.
  1. Finally, click on Publish button to save the metadata.

Best Practices

By following these best practices, you can make the most of Tellius Copilot and ensure the generated suggestions are relevant to your requirements.

  1. If you are using Copilot to generate metadata for multiple columns, try to limit the number of columns to 25 or fewer. This will help optimize performance and ensure that the suggestions are generated quickly and accurately.
  2. Copilot gives users full control over which suggestions to accept and which to discard. It's important to review each suggestion carefully and consider its relevance and accuracy before accepting or discarding it.

FAQs

  1. Is Tellius Copilot active by default?

We believe in providing controls based on the policies and governance of our customers. Admins can opt-in to activate Tellius Copilot for all their users.

  1. Which version of GPT is being used?

Currently, Tellius Copilot supports GPT-3 and GPT-3.5. We have plans to extend support for additional LLMs.

  1. How accurate are the suggestions and recommendations generated by Tellius Copilot?

We apply a layer of governance and guardrails to ensure the quality of results. However, as is inherent and unavoidable in AI systems, the AI-generated suggestions might be occasionally inaccurate. Please use it for assistance, review the suggestions/recommendations, and update as required.

  1. Can I still manually adjust the metadata and code generated by Tellius Copilot?

We believe that users should have the final say. You have full control over accepting, rejecting, or updating the suggestions and recommendations generated by Tellius Copilot.

  1. Can I provide feedback or suggest new use cases?

We are more than happy to chat with users on Tellius Copilot or Tellius as a platform. Please reach out to product@tellius.com, and we will connect with you.

  1. How secure is Tellius Copilot?

At Tellius, we prioritize data privacy and security. Necessary data (e.g., table and column names, SQL/Python code etc.) is passed to OpenAI for autogenerated responses. Data is encrypted in motion and secured at rest via standard Tellius security protocols. OpenAI has stated that they do not use data submitted by customers via API to train OpenAI models or improve OpenAI’s service offering. If you are not comfortable sharing data with a third-party like OpenAI, we do not recommend using Tellius Copilot.

Did we help you?

Customizing Tellius

Contact