I am fairly new to Drupal, and just started working with Drupal 8. I know a table can be generated in Views for the content which is displayed/used somewhere on the site, and a table can also be generated as a "Content" with manual entries in there.

But I have a MySQL table - in a non-Drupal external database. I would like to use the data in that table, and generate a table on my Drupal site using that data, either as a View, or a Content, or something else.

Are there any suggestions on how I can go about doing that?

closed as unclear what you're asking by leymannx, kiamlaluno Jul 31 at 20:34

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • Welcome to Drupal Answers :) Isn't your question actually "How can I pull data from an external database to be displayed in a View?" or something like that? Still quite broad though... – leymannx Jul 31 at 18:06

There are a couple of solutions to do this.

First one is to convert your data into nodes (content) and then easily show them in Views as a table. (You might achieve this using the Feeds module. Export your table data as CSV and use Feeds to import it as a new content type.)

Second solution is to use the Views Custom Table module.


View custom table module provide you functionality to integrate your custom table data to views, and access all it's column in views. This module use hook_view_data to add custom tables in views. this module provides you following functionalities.

Not the answer you're looking for? Browse other questions tagged or ask your own question.