Tables from MSSQL not showing on Table View

[syazshafei]

Expected results

MSSQL database tables showing on Table View

Actual results

No MSSQL tables showed

Screenshots

1. Database configuration
   
2. Tables detected
   
3. Table view
   

Environment

• superset version: 0.28.1
• python version: 3.6
• node.js version: 10.16.0
• npm version: 6.9.0

Checklist

Make sure these boxes are checked before submitting your issue - thank you!

• I have checked the superset logs for python stacktraces and included it here as text if there are any.
• I have reproduced the issue with at least the latest released version of superset.
• I have checked the issue tracker for the same issue and I haven't found one similar.

[issue-label-bot]

Issue-Label Bot is automatically applying the label #bug to this issue, with a confidence of 0.99. Please mark this comment with 👍 or 👎 to give our bot feedback!

Links: app homepage, dashboard and code for this bot.

[villebro]

You need to add each table, they are not automatically added (click the button on the upper right hand corner on the tables page). There has been a few important fixes for MSSQL after version 0.28, so you might want to try one of the more recent versions if you run into trouble.

[syazshafei]

I tried with more recent version which is 0.33.0rc1, but still got the same output.

[villebro]

Every table has to be manually added in Superset; on the tables page, click the plus sign on the right hand corner of the tables page to create a datasource referencing the table in your database.

[villebro]

@syazwan0913 was there still something that required help/fixing, or can this issue be closed?

[syazshafei]

I already add manually the table from MSSQL database
Schema: dbo
Table: Main

But when I tried to refresh metadata, this error appeared,

[syazshafei]

@villebro @mistercrunch So any way to fix that?

[vitorbellini]

Same error here

[vitorbellini]

Solution here #4271 thanks to @googlerobot

Run query below at the Superset Metabase

ALTER TABLE public.table_columns
ALTER COLUMN "type" TYPE varchar(128);

[syazshafei]

@vitorbellini Thanks. I already can add sql server table. Btw, is there any way to fix this bug by changing the source code?

[villebro]

@syazwan0913 are you able to test #7963 which should fix this problem?

[syazshafei]

@villebro I already tested it with master branch and it is okay.