How to Display a Snowflake Dashboard with OptiSigns

• What You'll Need 
• Creating a Snowflake App 
• Deploying a Snowflake App
• Frequently Asked Questions

If you want to display a Snowflake Dashboard, this can be accomplished with the dedicated Snowflake app within OptiSigns. This article will show how to set that up.

What You'll Need

• An OptiSigns account - Pro Plus Plan or higher 
• Access to Snowflake - specifically internal reports like Snowsight and Streamlit, with Snowflake Authentication 
• An OptiSigns-enabled device 
• A screen, set up and paired with OptiSigns

Create a Snowflake App

At the risk of repeating ourselves, don't forget that this is specifically for internal reports - Snowsight or Streamlit with Snowflake Authentication. Other applications of Snowflake will not work with OptiSigns.

To set up a Snowflake app, go to the Files/Assets tab, then click Apps on the left side of the screen:

Find and click on Snowflake.

Enter the details for your Snowflake site.

• Name - This is the name of your asset. It is for internal OptiSigns use and will not display on your screens.
• URL - The URL of your Snowflake Report. Please note that this must be a Snowsight or Streamlit report with Snowflake authentication.
• Update Interval - How often, in seconds, the dashboard reloads. This is useful if you choose to display the Snowflake asset by itself. When placed in a Playlist, the Snowflake asset will automatically update. Note that setting the number to "0" will have it reload only upon first load.
• Sign In
  • Master Password - When checked, this will prompt you to enter a Master Password for use on OptiSigns.
    • While your password is encrypted with OptiSigns, this adds an extra layer of encryption. This way, even OptiSigns cannot decrypt your password. More detail in the FAQ section.
  • Username / Email - The Username or Email associated with the Snowflake report.
  • Password - The password associated with the Snowflake report.
  • Secret 2FA - This is the Secret Key. Only needed if your login requires 2FA. We go over how to obtain this in the FAQ section.
  • Recorded 2FA Code - If your login requires 2FA, this is where you input the code you received. Paired with the Secret Key, this keeps your 2FA channel open for this asset to use repeatedly.
• Delay Execute 2FA JavaScript - Delays execution of JavaScript elements on the 2FA element by a set amount of time, measured in seconds.
• Delay Execute JavaScript - Delays execution of JavaScript elements on the Snowflake report by a set amount of time, measured in seconds.

Deploying a Snowflake App

You can deploy your new Snowflake app as an individual asset, or as part of a Split Screen.

To get your new Snowflake asset to a screen, go to the Screens tab, then click the screen you want to assign it to.

This brings us to the Edit Screen tab:

Here, select Asset under Content type. If you already have an Asset, Playlist, or Schedule selected, you can hit Change.

Then, select your created Snowflake Asset:

Now hit Save. Your Snowflake asset will now display on screen. 

You can also deploy it as part of a split screen, allowing you to show other assets at the same time. See how in our Split Screen app article. It can also be displayed in a Playlist or Schedule.

Frequently Asked Questions

How does the encryption of my password work at OptiSigns? If I input it, will I be at risk?

Here's how the encryption flow works:

When you input your Username and Password into the OptiSigns Snowflake app, it is being utilized as a Web Script. This script is encrypted at your browser, and transferred securely using HTTPS/SSL during transits and stored on our servers.

It is then sent via the same method to devices, and decrypted at device level before executing on the target website. In this case, that's Snowflake.

If you want to add additional security by utilizing a Master Password and our Zero Knowledge Encryption framework, you will have to enter your Master Password when:

• Creating/editing assets
• One time on each device, so it will know how to decrypt

The Master Password can be input on OptiSigns devices under the Advanced Options menu under Master Password.

The Master Password can then be input. It will need to match the Master Password field input on your assets.

This will ensure no one, not even OptiSigns, can decrypt your password under any circumstance.

How do I obtain my Snowflake 2FA information?

If 2FA is enabled on your login, you'll need to obtain a Secret Key.

To get this, click the "I Can't Scan the QR Code" button on your authenticator.

It will provide you with a Secret Key.

Copy this Secret Key for use later, then finish the 2FA process.

Now, record the script as described in the above step.

After this step, you should have:

• 2FA Secret Key
• 2FA Code

Now your Snowflake asset can be displayed securely.

That's all!

OptiSigns is a leader in digital signage software. If you have any additional questions, concerns or any feedback about OptiSigns or getting Snowflake to work on it, feel free to reach out to our support team at support@optisigns.com.